Overview

Brought to you by YData

Dataset statistics

Number of variables	22
Number of observations	6901265
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	796.4 MiB
Average record size in memory	121.0 B

Variable types

Categorical	3
Numeric	7
Text	3
Boolean	9

Alerts

`Severity` is highly imbalanced (56.2%)	Imbalance
`Amenity` is highly imbalanced (90.3%)	Imbalance
`Give_Way` is highly imbalanced (95.8%)	Imbalance
`Junction` is highly imbalanced (62.4%)	Imbalance
`No_Exit` is highly imbalanced (97.4%)	Imbalance
`Railway` is highly imbalanced (92.9%)	Imbalance
`Stop` is highly imbalanced (81.7%)	Imbalance
`Traffic_Calming` is highly imbalanced (98.9%)	Imbalance
`Duration_Seconds` is highly skewed (γ1 = 56.22205817)	Skewed
`Distance(mi)` has 2931021 (42.5%) zeros	Zeros
`Wind_Speed(mph)` has 915200 (13.3%) zeros	Zeros

Reproduction

Analysis started	2024-11-04 23:43:16.089487
Analysis finished	2024-11-04 23:48:09.506524
Duration	4 minutes and 53.42 seconds
Software version	ydata-profiling vv4.12.0
Download configuration	config.json

Severity
Categorical

Imbalance

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	105.3 MiB

2	5538813
3	1128444
4	172262
1	61746

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	6901265
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2
2nd row	3
3rd row	2
4th row	3
5th row	2

Common Values

Value	Count	Frequency (%)
2	5538813	80.3%
3	1128444	16.4%
4	172262	2.5%
1	61746	0.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2	5538813	80.3%
3	1128444	16.4%
4	172262	2.5%
1	61746	0.9%

Most occurring characters

Value	Count	Frequency (%)
2	5538813	80.3%
3	1128444	16.4%
4	172262	2.5%
1	61746	0.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	6901265	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
2	5538813	80.3%
3	1128444	16.4%
4	172262	2.5%
1	61746	0.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	6901265	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
2	5538813	80.3%
3	1128444	16.4%
4	172262	2.5%
1	61746	0.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	6901265	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
2	5538813	80.3%
3	1128444	16.4%
4	172262	2.5%
1	61746	0.9%

Distance(mi)
Real number (ℝ)

Zeros

Distinct	21687
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.5644842

Minimum	0
Maximum	441.75
Zeros	2931021
Zeros (%)	42.5%
Negative	0
Negative (%)	0.0%
Memory size	105.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.034
Q3	0.47
95-th percentile	2.679
Maximum	441.75
Range	441.75
Interquartile range (IQR)	0.47

Descriptive statistics

Standard deviation	1.7655502
Coefficient of variation (CV)	3.1277229
Kurtosis	1602.9111
Mean	0.5644842
Median Absolute Deviation (MAD)	0.034
Skewness	19.967062
Sum	3895655
Variance	3.1171674
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2931021	42.5%
0.01	211640	3.1%
0.008	13340	0.2%
0.009	12678	0.2%
0.007	11258	0.2%
0.009999999776	11065	0.2%
0.011	10572	0.2%
0.03	10343	0.1%
0.024	9985	0.1%
0.029	9896	0.1%
Other values (21677)	3669467	53.2%

Value	Count	Frequency (%)
0	2931021	42.5%
0.001	4317	0.1%
0.002	2459	< 0.1%
0.003	3673	0.1%
0.004	5607	0.1%
0.005	7429	0.1%
0.006	9167	0.1%
0.007	11258	0.2%
0.008	13340	0.2%
0.009	12678	0.2%

Value	Count	Frequency (%)
441.75	1	< 0.1%
336.5700073	1	< 0.1%
254.3999939	1	< 0.1%
251.2200012	1	< 0.1%
242.3399963	1	< 0.1%
224.5899963	1	< 0.1%
210.0800018	1	< 0.1%
194.7299957	1	< 0.1%
193.4799957	1	< 0.1%
183.1199951	1	< 0.1%

Street
Text

Distinct	320207
Distinct (%)	4.6%
Missing	0
Missing (%)	0.0%
Memory size	105.3 MiB

Length

Max length	59
Median length	47
Mean length	11.061614
Min length	1

Characters and Unicode

Total characters	76339130
Distinct characters	80
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	126725 ?
Unique (%)	1.8%

Sample

1st row	State Route 32
2nd row	I-75 S
3rd row	Miamisburg Centerville Rd
4th row	Westerville Rd
5th row	N Woodward Ave

Value	Count	Frequency (%)
n	1070416	6.2%
s	1067855	6.2%
rd	1035170	6.0%
w	842301	4.9%
e	831585	4.9%
st	617863	3.6%
ave	579195	3.4%
blvd	309195	1.8%
dr	296470	1.7%
fwy	282591	1.6%
Other values (71822)	10205531	59.5%

Most occurring characters

Value	Count	Frequency (%)
	11782569	15.4%
e	4255206	5.6%
a	3395080	4.4%
r	2898786	3.8%
t	2873613	3.8%
S	2667274	3.5%
o	2665140	3.5%
n	2657983	3.5%
d	2489396	3.3%
l	2471132	3.2%
Other values (70)	38182951	50.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	76339130	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	11782569	15.4%
e	4255206	5.6%
a	3395080	4.4%
r	2898786	3.8%
t	2873613	3.8%
S	2667274	3.5%
o	2665140	3.5%
n	2657983	3.5%
d	2489396	3.3%
l	2471132	3.2%
Other values (70)	38182951	50.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	76339130	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	11782569	15.4%
e	4255206	5.6%
a	3395080	4.4%
r	2898786	3.8%
t	2873613	3.8%
S	2667274	3.5%
o	2665140	3.5%
n	2657983	3.5%
d	2489396	3.3%
l	2471132	3.2%
Other values (70)	38182951	50.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	76339130	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	11782569	15.4%
e	4255206	5.6%
a	3395080	4.4%
r	2898786	3.8%
t	2873613	3.8%
S	2667274	3.5%
o	2665140	3.5%
n	2657983	3.5%
d	2489396	3.3%
l	2471132	3.2%
Other values (70)	38182951	50.0%

Zipcode
Text

Distinct	774620
Distinct (%)	11.2%
Missing	0
Missing (%)	0.0%
Memory size	105.3 MiB

Length

Max length	10
Median length	5
Mean length	6.4827506
Min length	5

Characters and Unicode

Total characters	44739180
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	434113 ?
Unique (%)	6.3%

Sample

1st row	45176
2nd row	45417
3rd row	45459
4th row	43081
5th row	45417-2476

Value	Count	Frequency (%)
91761	10471	0.2%
91706	8571	0.1%
92507	8001	0.1%
92407	7887	0.1%
33186	7750	0.1%
32819	7186	0.1%
33169	6515	0.1%
75243	6493	0.1%
92324	6204	0.1%
90805	6156	0.1%
Other values (774610)	6826031	98.9%

Most occurring characters

Value	Count	Frequency (%)
0	5615634	12.6%
2	5484006	12.3%
3	5135505	11.5%
1	5087549	11.4%
9	3955798	8.8%
7	3873580	8.7%
5	3773880	8.4%
4	3721190	8.3%
6	3083833	6.9%
8	2956082	6.6%
Other values (3)	2052123	4.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	44739180	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	5615634	12.6%
2	5484006	12.3%
3	5135505	11.5%
1	5087549	11.4%
9	3955798	8.8%
7	3873580	8.7%
5	3773880	8.4%
4	3721190	8.3%
6	3083833	6.9%
8	2956082	6.6%
Other values (3)	2052123	4.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	44739180	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	5615634	12.6%
2	5484006	12.3%
3	5135505	11.5%
1	5087549	11.4%
9	3955798	8.8%
7	3873580	8.7%
5	3773880	8.4%
4	3721190	8.3%
6	3083833	6.9%
8	2956082	6.6%
Other values (3)	2052123	4.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	44739180	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	5615634	12.6%
2	5484006	12.3%
3	5135505	11.5%
1	5087549	11.4%
9	3955798	8.8%
7	3873580	8.7%
5	3773880	8.4%
4	3721190	8.3%
6	3083833	6.9%
8	2956082	6.6%
Other values (3)	2052123	4.6%

Temperature(F)
Real number (ℝ)

Distinct	829
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	61.960111

Minimum	-45
Maximum	196
Zeros	2574
Zeros (%)	< 0.1%
Negative	17638
Negative (%)	0.3%
Memory size	105.3 MiB

Quantile statistics

Minimum	-45
5-th percentile	28
Q1	50
median	64
Q3	76
95-th percentile	89
Maximum	196
Range	241
Interquartile range (IQR)	26

Descriptive statistics

Standard deviation	19.039681
Coefficient of variation (CV)	0.30728933
Kurtosis	-0.0065594547
Mean	61.960111
Median Absolute Deviation (MAD)	13
Skewness	-0.52706124
Sum	4.2760315 × 10⁸
Variance	362.50946
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
73	159649	2.3%
77	158016	2.3%
72	149860	2.2%
68	148989	2.2%
75	148139	2.1%
70	144354	2.1%
79	138701	2.0%
63	138398	2.0%
64	136710	2.0%
66	133943	1.9%
Other values (819)	5444506	78.9%

Value	Count	Frequency (%)
-45	1	< 0.1%
-38	3	< 0.1%
-36	2	< 0.1%
-35	9	< 0.1%
-33	1	< 0.1%
-30	1	< 0.1%
-29	8	< 0.1%
-28	5	< 0.1%
-27.9	12	< 0.1%
-27.4	3	< 0.1%

Value	Count	Frequency (%)
196	5	< 0.1%
189	1	< 0.1%
174	2	< 0.1%
172	2	< 0.1%
170.6	1	< 0.1%
168.8	1	< 0.1%
167	1	< 0.1%
162	2	< 0.1%
161.6	1	< 0.1%
143.6	1	< 0.1%

Humidity(%)
Real number (ℝ)

Distinct	100
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	64.396618

Minimum	1
Maximum	100
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	105.3 MiB

Quantile statistics

Minimum	1
5-th percentile	24
Q1	48
median	66
Q3	84
95-th percentile	96
Maximum	100
Range	99
Interquartile range (IQR)	36

Descriptive statistics

Standard deviation	22.742039
Coefficient of variation (CV)	0.35315581
Kurtosis	-0.72765416
Mean	64.396618
Median Absolute Deviation (MAD)	18
Skewness	-0.37822121
Sum	4.4441812 × 10⁸
Variance	517.20036
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
93	258266	3.7%
100	240251	3.5%
87	153111	2.2%
90	150704	2.2%
89	125416	1.8%
96	117802	1.7%
81	114953	1.7%
84	114935	1.7%
82	112275	1.6%
86	109189	1.6%
Other values (90)	5404363	78.3%

Value	Count	Frequency (%)
1	44	< 0.1%
2	187	< 0.1%
3	641	< 0.1%
4	2023	< 0.1%
5	3883	0.1%
6	5641	0.1%
7	7485	0.1%
8	8894	0.1%
9	10291	0.1%
10	12508	0.2%

Value	Count	Frequency (%)
100	240251	3.5%
99	12525	0.2%
98	5980	0.1%
97	77544	1.1%
96	117802	1.7%
95	8330	0.1%
94	102755	1.5%
93	258266	3.7%
92	59033	0.9%
91	33914	0.5%

Pressure(in)
Real number (ℝ)

Distinct	1126
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	29.519031

Minimum	0
Maximum	58.63
Zeros	2
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	105.3 MiB

Quantile statistics

Minimum	0
5-th percentile	27.91
Q1	29.34
median	29.84
Q3	30.02
95-th percentile	30.24
Maximum	58.63
Range	58.63
Interquartile range (IQR)	0.68

Descriptive statistics

Standard deviation	1.0090751
Coefficient of variation (CV)	0.034183882
Kurtosis	20.232115
Mean	29.519031
Median Absolute Deviation (MAD)	0.25
Skewness	-3.5722688
Sum	2.0371866 × 10⁸
Variance	1.0182325
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
29.96	109975	1.6%
29.99	107870	1.6%
29.94	106728	1.5%
30.01	104743	1.5%
29.97	100788	1.5%
29.91	99909	1.4%
30.04	99074	1.4%
29.95	98835	1.4%
30.03	97640	1.4%
30	97444	1.4%
Other values (1116)	5878259	85.2%

Value	Count	Frequency (%)
0	2	< 0.1%
0.02	1	< 0.1%
0.29	2	< 0.1%
0.39	1	< 0.1%
2.99	5	< 0.1%
3	2	< 0.1%
3.01	1	< 0.1%
3.04	4	< 0.1%
9.9	2	< 0.1%
16.71	1	< 0.1%

Value	Count	Frequency (%)
58.63	7	< 0.1%
58.39	2	< 0.1%
58.32	1	< 0.1%
58.13	1	< 0.1%
58.1	4	< 0.1%
58.04	3	< 0.1%
57.74	1	< 0.1%
57.54	2	< 0.1%
56.54	1	< 0.1%
56.31	1	< 0.1%

Visibility(mi)
Real number (ℝ)

Distinct	81
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.1090536

Minimum	0
Maximum	140
Zeros	6994
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	105.3 MiB

Quantile statistics

Minimum	0
5-th percentile	2.5
Q1	10
median	10
Q3	10
95-th percentile	10
Maximum	140
Range	140
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	2.6414816
Coefficient of variation (CV)	0.2899842
Kurtosis	80.609317
Mean	9.1090536
Median Absolute Deviation (MAD)	0
Skewness	2.1313248
Sum	62863992
Variance	6.9774251
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10	5580997	80.9%
7	190662	2.8%
9	168643	2.4%
8	133938	1.9%
5	127469	1.8%
6	113352	1.6%
2	112662	1.6%
4	107172	1.6%
3	106175	1.5%
1	95411	1.4%
Other values (71)	164784	2.4%

Value	Count	Frequency (%)
0	6994	0.1%
0.06	311	< 0.1%
0.1	865	< 0.1%
0.12	1704	< 0.1%
0.19	40	< 0.1%
0.2	7134	0.1%
0.25	25633	0.4%
0.31	4	< 0.1%
0.38	316	< 0.1%
0.4	51	< 0.1%

Value	Count	Frequency (%)
140	1	< 0.1%
111	3	< 0.1%
105	1	< 0.1%
101	1	< 0.1%
100	46	< 0.1%
98	1	< 0.1%
90	12	< 0.1%
80	288	< 0.1%
78	1	< 0.1%
76	3	< 0.1%

Wind_Direction
Categorical

Distinct	23
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	105.3 MiB

CALM	915192
S	404009
SSW	372557
W	368759
WNW	365224
Other values (18)	4475524

Length

Max length	8
Median length	5
Mean length	2.770933
Min length	1

Characters and Unicode

Total characters	19122943
Distinct characters	21
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	SW
2nd row	SW
3rd row	SW
4th row	SSW
5th row	WSW

Common Values

Value	Count	Frequency (%)
CALM	915192	13.3%
S	404009	5.9%
SSW	372557	5.4%
W	368759	5.3%
WNW	365224	5.3%
NW	356045	5.2%
SW	353083	5.1%
WSW	342045	5.0%
SSE	337450	4.9%
NNW	320915	4.7%
Other values (13)	2765986	40.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
calm	915192	13.3%
s	404009	5.9%
ssw	372557	5.4%
w	368759	5.3%
wnw	365224	5.3%
nw	356045	5.2%
sw	353083	5.1%
wsw	342045	5.0%
sse	337450	4.9%
nnw	320915	4.7%
Other values (13)	2765986	40.1%

Most occurring characters

Value	Count	Frequency (%)
W	3347092	17.5%
S	3238611	16.9%
N	2772411	14.5%
E	2506338	13.1%
A	1156947	6.1%
M	915192	4.8%
L	915192	4.8%
C	915192	4.8%
t	561163	2.9%
V	353115	1.8%
Other values (11)	2441690	12.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	19122943	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
W	3347092	17.5%
S	3238611	16.9%
N	2772411	14.5%
E	2506338	13.1%
A	1156947	6.1%
M	915192	4.8%
L	915192	4.8%
C	915192	4.8%
t	561163	2.9%
V	353115	1.8%
Other values (11)	2441690	12.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	19122943	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
W	3347092	17.5%
S	3238611	16.9%
N	2772411	14.5%
E	2506338	13.1%
A	1156947	6.1%
M	915192	4.8%
L	915192	4.8%
C	915192	4.8%
t	561163	2.9%
V	353115	1.8%
Other values (11)	2441690	12.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	19122943	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
W	3347092	17.5%
S	3238611	16.9%
N	2772411	14.5%
E	2506338	13.1%
A	1156947	6.1%
M	915192	4.8%
L	915192	4.8%
C	915192	4.8%
t	561163	2.9%
V	353115	1.8%
Other values (11)	2441690	12.8%

Wind_Speed(mph)
Real number (ℝ)

Zeros

Distinct	179
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.6988973

Minimum	0
Maximum	1087
Zeros	915200
Zeros (%)	13.3%
Negative	0
Negative (%)	0.0%
Memory size	105.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	4.6
median	7
Q3	10.4
95-th percentile	17
Maximum	1087
Range	1087
Interquartile range (IQR)	5.8

Descriptive statistics

Standard deviation	5.4065039
Coefficient of variation (CV)	0.70224394
Kurtosis	1117.1177
Mean	7.6988973
Median Absolute Deviation (MAD)	3
Skewness	8.1183667
Sum	53132130
Variance	29.230285
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	915200	13.3%
5	512320	7.4%
6	496040	7.2%
3	492665	7.1%
7	461892	6.7%
8	415707	6.0%
9	374028	5.4%
10	311990	4.5%
12	269587	3.9%
4.6	213643	3.1%
Other values (169)	2438193	35.3%

Value	Count	Frequency (%)
0	915200	13.3%
1	163	< 0.1%
1.2	436	< 0.1%
2	417	< 0.1%
2.3	882	< 0.1%
3	492665	7.1%
3.5	199934	2.9%
4.6	213643	3.1%
5	512320	7.4%
5.8	211891	3.1%

Value	Count	Frequency (%)
1087	1	< 0.1%
984	1	< 0.1%
822.8	7	< 0.1%
812	1	< 0.1%
703.1	2	< 0.1%
580	2	< 0.1%
471.8	1	< 0.1%
328	1	< 0.1%
255	1	< 0.1%
254.3	2	< 0.1%

Weather_Condition
Text

Distinct	140
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	105.3 MiB

Length

Max length	35
Median length	30
Mean length	7.6872585
Min length	3

Characters and Unicode

Total characters	53051808
Distinct characters	46
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	8 ?
Unique (%)	< 0.1%

Sample

1st row	Overcast
2nd row	Mostly Cloudy
3rd row	Mostly Cloudy
4th row	Light Rain
5th row	Overcast

Value	Count	Frequency (%)
fair	2470211	25.7%
cloudy	2418446	25.2%
mostly	964545	10.1%
partly	660362	6.9%
clear	610683	6.4%
light	508377	5.3%
rain	474794	4.9%
overcast	319799	3.3%
scattered	175020	1.8%
clouds	175020	1.8%
Other values (48)	819626	8.5%

Most occurring characters

Value	Count	Frequency (%)
l	4865647	9.2%
a	4846338	9.1%
r	4382400	8.3%
y	4225496	8.0%
o	3867241	7.3%
i	3710765	7.0%
C	3204165	6.0%
d	2938459	5.5%
t	2917761	5.5%
	2695618	5.1%
Other values (36)	15397918	29.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	53051808	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
l	4865647	9.2%
a	4846338	9.1%
r	4382400	8.3%
y	4225496	8.0%
o	3867241	7.3%
i	3710765	7.0%
C	3204165	6.0%
d	2938459	5.5%
t	2917761	5.5%
	2695618	5.1%
Other values (36)	15397918	29.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	53051808	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
l	4865647	9.2%
a	4846338	9.1%
r	4382400	8.3%
y	4225496	8.0%
o	3867241	7.3%
i	3710765	7.0%
C	3204165	6.0%
d	2938459	5.5%
t	2917761	5.5%
	2695618	5.1%
Other values (36)	15397918	29.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	53051808	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
l	4865647	9.2%
a	4846338	9.1%
r	4382400	8.3%
y	4225496	8.0%
o	3867241	7.3%
i	3710765	7.0%
C	3204165	6.0%
d	2938459	5.5%
t	2917761	5.5%
	2695618	5.1%
Other values (36)	15397918	29.0%

Amenity
Boolean

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	59.2 MiB

False	6815353
True	85912

Value	Count	Frequency (%)
False	6815353	98.8%
True	85912	1.2%

Crossing
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	59.2 MiB

False	6109696
True	791569

Value	Count	Frequency (%)
False	6109696	88.5%
True	791569	11.5%

Give_Way
Boolean

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	59.2 MiB

False	6869396
True	31869

Value	Count	Frequency (%)
False	6869396	99.5%
True	31869	0.5%

Junction
Boolean

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	59.2 MiB

False	6399773
True	501492

Value	Count	Frequency (%)
False	6399773	92.7%
True	501492	7.3%

No_Exit
Boolean

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	59.2 MiB

False	6883495
True	17770

Value	Count	Frequency (%)
False	6883495	99.7%
True	17770	0.3%

Railway
Boolean

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	59.2 MiB

False	6841971
True	59294

Value	Count	Frequency (%)
False	6841971	99.1%
True	59294	0.9%

Stop
Boolean

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	59.2 MiB

False	6709990
True	191275

Value	Count	Frequency (%)
False	6709990	97.2%
True	191275	2.8%

Traffic_Calming
Boolean

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	59.2 MiB

False	6894414
True	6851

Value	Count	Frequency (%)
False	6894414	99.9%
True	6851	0.1%

Traffic_Signal
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	59.2 MiB

False	5881403
True	1019862

Value	Count	Frequency (%)
False	5881403	85.2%
True	1019862	14.8%

Civil_Twilight
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	105.3 MiB

Day	5160127
Night	1741138

Length

Max length	5
Median length	3
Mean length	3.5045852
Min length	3

Characters and Unicode

Total characters	24186071
Distinct characters	8
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Night
2nd row	Day
3rd row	Day
4th row	Day
5th row	Day

Common Values

Value	Count	Frequency (%)
Day	5160127	74.8%
Night	1741138	25.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
day	5160127	74.8%
night	1741138	25.2%

Most occurring characters

Value	Count	Frequency (%)
D	5160127	21.3%
a	5160127	21.3%
y	5160127	21.3%
N	1741138	7.2%
i	1741138	7.2%
g	1741138	7.2%
h	1741138	7.2%
t	1741138	7.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	24186071	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
D	5160127	21.3%
a	5160127	21.3%
y	5160127	21.3%
N	1741138	7.2%
i	1741138	7.2%
g	1741138	7.2%
h	1741138	7.2%
t	1741138	7.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	24186071	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
D	5160127	21.3%
a	5160127	21.3%
y	5160127	21.3%
N	1741138	7.2%
i	1741138	7.2%
g	1741138	7.2%
h	1741138	7.2%
t	1741138	7.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	24186071	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
D	5160127	21.3%
a	5160127	21.3%
y	5160127	21.3%
N	1741138	7.2%
i	1741138	7.2%
g	1741138	7.2%
h	1741138	7.2%
t	1741138	7.2%

Duration_Seconds
Real number (ℝ)

Skewed

Distinct	72892
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	23931.489

Minimum	120
Maximum	1.6877634 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	105.3 MiB

Quantile statistics

Minimum	120
5-th percentile	1719
Q1	2014
median	4500
Q3	7506
95-th percentile	21600
Maximum	1.6877634 × 10⁸
Range	1.6877622 × 10⁸
Interquartile range (IQR)	5492

Descriptive statistics

Standard deviation	758788.58
Coefficient of variation (CV)	31.706702
Kurtosis	4638.6566
Mean	23931.489
Median Absolute Deviation (MAD)	2704
Skewness	56.222058
Sum	1.6515755 × 10¹¹
Variance	5.7576012 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
21600	295021	4.3%
1800	95582	1.4%
2700	58150	0.8%
4500	56342	0.8%
3600	51550	0.7%
14400	49404	0.7%
1786	46589	0.7%
1785	46544	0.7%
1787	45507	0.7%
1784	45129	0.7%
Other values (72882)	6111447	88.6%

Value	Count	Frequency (%)
120	2	< 0.1%
150	3	< 0.1%
152	1	< 0.1%
180	16	< 0.1%
210	6	< 0.1%
221	1	< 0.1%
229	1	< 0.1%
240	12	< 0.1%
270	5	< 0.1%
271	1	< 0.1%

Value	Count	Frequency (%)
168776340	2	< 0.1%
134184345	1	< 0.1%
134181332	3	< 0.1%
134179838	3	< 0.1%
134176830	2	< 0.1%
106135755	1	< 0.1%
100954757	1	< 0.1%
94755540	1	< 0.1%
94697995	1	< 0.1%
94697990	1	< 0.1%

Interactions

Correlations

	Amenity	Civil_Twilight	Crossing	Distance(mi)	Duration_Seconds	Give_Way	Humidity(%)	Junction	No_Exit	Pressure(in)	Railway	Severity	Stop	Temperature(F)	Traffic_Calming	Traffic_Signal	Visibility(mi)	Wind_Direction	Wind_Speed(mph)
Amenity	1.000	0.006	0.148	0.000	0.001	0.006	0.015	0.026	0.014	0.023	0.050	0.038	0.034	0.010	0.023	0.104	0.002	0.022	0.000
Civil_Twilight	0.006	1.000	0.038	0.003	0.007	0.005	0.243	0.014	0.004	0.034	0.000	0.056	0.001	0.278	0.000	0.044	0.015	0.180	0.001
Crossing	0.148	0.038	1.000	0.004	0.007	0.058	0.035	0.088	0.062	0.035	0.179	0.121	0.119	0.061	0.037	0.475	0.007	0.054	0.001
Distance(mi)	0.000	0.003	0.004	1.000	0.391	0.000	-0.013	0.000	0.000	-0.106	0.000	0.005	0.002	-0.058	0.001	0.004	-0.012	0.001	-0.002
Duration_Seconds	0.001	0.007	0.007	0.391	1.000	0.001	-0.013	0.008	0.000	-0.114	0.001	0.009	0.003	-0.030	0.000	0.008	0.005	0.005	-0.036
Give_Way	0.006	0.005	0.058	0.000	0.001	1.000	0.004	0.009	0.007	0.008	0.003	0.008	0.030	0.005	0.003	0.072	0.007	0.010	0.000
Humidity(%)	0.015	0.243	0.035	-0.013	-0.013	0.004	1.000	0.009	0.009	0.043	0.006	0.027	0.026	-0.331	0.005	0.021	-0.465	0.084	-0.198
Junction	0.026	0.014	0.088	0.000	0.008	0.009	0.009	1.000	0.004	0.027	0.009	0.053	0.036	0.027	0.005	0.104	0.004	0.030	0.000
No_Exit	0.014	0.004	0.062	0.000	0.000	0.007	0.009	0.004	1.000	0.007	0.004	0.012	0.026	0.009	0.013	0.030	0.007	0.006	0.000
Pressure(in)	0.023	0.034	0.035	-0.106	-0.114	0.008	0.043	0.027	0.007	1.000	0.016	0.042	0.003	0.018	0.005	0.034	0.078	0.078	0.001
Railway	0.050	0.000	0.179	0.000	0.001	0.003	0.006	0.009	0.004	0.016	1.000	0.014	0.007	0.010	0.005	0.059	0.003	0.007	0.000
Severity	0.038	0.056	0.121	0.005	0.009	0.008	0.027	0.053	0.012	0.042	0.014	1.000	0.059	0.038	0.006	0.120	0.012	0.096	0.001
Stop	0.034	0.001	0.119	0.002	0.003	0.030	0.026	0.036	0.026	0.003	0.007	0.059	1.000	0.016	0.027	0.048	0.001	0.009	0.000
Temperature(F)	0.010	0.278	0.061	-0.058	-0.030	0.005	-0.331	0.027	0.009	0.018	0.010	0.038	0.016	1.000	0.006	0.047	0.229	0.083	0.087
Traffic_Calming	0.023	0.000	0.037	0.001	0.000	0.003	0.005	0.005	0.013	0.005	0.005	0.006	0.027	0.006	1.000	0.011	0.002	0.006	0.000
Traffic_Signal	0.104	0.044	0.475	0.004	0.008	0.072	0.021	0.104	0.030	0.034	0.059	0.120	0.048	0.047	0.011	1.000	0.002	0.075	0.002
Visibility(mi)	0.002	0.015	0.007	-0.012	0.005	0.007	-0.465	0.004	0.007	0.078	0.003	0.012	0.001	0.229	0.002	0.002	1.000	0.011	0.055
Wind_Direction	0.022	0.180	0.054	0.001	0.005	0.010	0.084	0.030	0.006	0.078	0.007	0.096	0.009	0.083	0.006	0.075	0.011	1.000	0.002
Wind_Speed(mph)	0.000	0.001	0.001	-0.002	-0.036	0.000	-0.198	0.000	0.000	0.001	0.000	0.001	0.000	0.087	0.000	0.002	0.055	0.002	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

	Severity	Distance(mi)	Street	Zipcode	Temperature(F)	Humidity(%)	Pressure(in)	Visibility(mi)	Wind_Direction	Wind_Speed(mph)	Weather_Condition	Amenity	Crossing	Give_Way	Junction	No_Exit	Railway	Stop	Traffic_Calming	Traffic_Signal	Civil_Twilight	Duration_Seconds
2	2	0.01	State Route 32	45176	36.0	100.0	29.67	10.0	SW	3.5	Overcast	False	False	False	False	False	False	False	False	True	Night	1800.0
3	3	0.01	I-75 S	45417	35.1	96.0	29.64	9.0	SW	4.6	Mostly Cloudy	False	False	False	False	False	False	False	False	False	Day	1800.0
4	2	0.01	Miamisburg Centerville Rd	45459	36.0	89.0	29.65	6.0	SW	3.5	Mostly Cloudy	False	False	False	False	False	False	False	False	True	Day	1800.0
5	3	0.01	Westerville Rd	43081	37.9	97.0	29.63	7.0	SSW	3.5	Light Rain	False	False	False	False	False	False	False	False	False	Day	1800.0
6	2	0.00	N Woodward Ave	45417-2476	34.0	100.0	29.66	7.0	WSW	3.5	Overcast	False	False	False	False	False	False	False	False	False	Day	1800.0
7	3	0.01	N Main St	45405	34.0	100.0	29.66	7.0	WSW	3.5	Overcast	False	False	False	False	False	False	False	False	False	Day	1800.0
8	2	0.00	Notre Dame Ave	45404-1923	33.3	99.0	29.67	5.0	SW	1.2	Mostly Cloudy	False	False	False	False	False	False	False	False	False	Day	1800.0
9	3	0.01	Westerville Rd	43081	37.4	100.0	29.62	3.0	SSW	4.6	Light Rain	False	False	False	False	False	False	False	False	False	Day	1800.0
10	3	0.01	Outerbelt S	43228	35.6	93.0	29.64	5.0	WNW	5.8	Rain	False	True	False	True	False	False	False	False	False	Day	1800.0
11	3	0.01	I-70 E	43068	37.4	100.0	29.62	3.0	SSW	4.6	Light Rain	False	False	False	False	False	False	False	False	False	Day	1800.0

	Severity	Distance(mi)	Street	Zipcode	Temperature(F)	Humidity(%)	Pressure(in)	Visibility(mi)	Wind_Direction	Wind_Speed(mph)	Weather_Condition	Amenity	Crossing	Give_Way	Junction	No_Exit	Railway	Stop	Traffic_Calming	Traffic_Signal	Civil_Twilight	Duration_Seconds
7728384	2	0.390	I-10 E	91706	78.0	52.0	29.69	10.0	VAR	6.0	Fair	False	False	False	False	False	False	False	False	False	Day	1723.0
7728385	2	0.000	CA-60 E	92555	88.0	32.0	28.20	10.0	WNW	10.0	Fair	False	False	False	False	False	False	False	False	False	Day	1703.0
7728386	2	0.189	El Camino Real N	93003	73.0	68.0	29.76	10.0	W	9.0	Fair	False	False	False	True	False	False	False	False	False	Day	1703.0
7728387	2	0.443	Santa Ana Fwy S	92780	75.0	60.0	29.74	10.0	SSW	9.0	Fair	False	False	False	False	False	False	False	False	False	Day	1711.0
7728388	2	0.000	Golden State Fwy N	91331	81.0	48.0	28.78	10.0	ESE	6.0	Fair	False	False	False	False	False	False	False	False	False	Day	1711.0
7728389	2	0.543	Pomona Fwy E	92501	86.0	40.0	28.92	10.0	W	13.0	Fair	False	False	False	False	False	False	False	False	False	Day	1716.0
7728390	2	0.338	I-8 W	92108	70.0	73.0	29.39	10.0	SW	6.0	Fair	False	False	False	False	False	False	False	False	False	Day	1613.0
7728391	2	0.561	Garden Grove Fwy	92866	73.0	64.0	29.74	10.0	SSW	10.0	Partly Cloudy	False	False	False	True	False	False	False	False	False	Day	1708.0
7728392	2	0.772	San Diego Fwy S	90230	71.0	81.0	29.62	10.0	SW	8.0	Fair	False	False	False	False	False	False	False	False	False	Day	1761.0
7728393	2	0.537	CA-210 W	92346	79.0	47.0	28.63	7.0	SW	7.0	Fair	False	False	False	False	False	False	False	False	False	Day	1765.0

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample